[dbo].[BAESecurityKeyUpdate]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAESecurityKeyUpdate

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@SecurityKey	varchar(64)	64
@Description	varchar(256)	256
@IsDynamicKey	bit	1
@StoredProcedureName	varchar(64)	64

SQL Script

create procedure [dbo].[BAESecurityKeyUpdate] @SecurityKey varchar(64),
     @Description varchar(256),
     @IsDynamicKey bit,
     @StoredProcedureName varchar(64) as
DELETE FROM SecurityKey WHERE SecurityKey = @SecurityKey;

    INSERT INTO SecurityKey (SecurityKey, [Description], IsDynamicKey, StoredProcedureName)
    VALUES(@SecurityKey, @Description, @IsDynamicKey , @StoredProcedureName)

GO

Uses